# create database p2p charset=utf8;
# use p2p

# #资源表
# create table resource(
#  id int primary key auto_increment,
#  name varchar(50) not null default '',
#  pid int default 0
# );


# #用户表
# create table admin_user(
#  id int primary key auto_increment,
#  name varchar(50) not null default '',
#  username varchar(30) not null default '',
#  password varchar(200) not null default '',
#  roleid int,
#  state int
# );


# #角色表
# create table roles(
#  id int primary key auto_increment,
#  name varchar(50) not null default ''
# );


# #角色资源表
# create table role_resource(
#  userid int,
#  resourceid int
# );



# create table poen_bank(
#  id int primary key auto_increment,
#  userid int,
#  image_url  varchar(200),
#  code varchar(200),
#  username varchar(20),
#  bank_code varchar(200),
#  mobile varchar (11),
#  pay_password varchar(200),
#  status  int
# );


# create table aggrement(
#  id int primary key auto_increment,
#  name varchar(50),
#  content text,
#  type int
# );


# 金额记录表
# create table top_up(
#  id int primary key auto_increment,
#  ddorder varchar(50),
#  userid int,
#  toptime varchar(100),
#  money  int,
#  bank_code varchar(20),
#  state varchar(10)
# );

# 生成订单表
# create table pageresource(
#  id int primary key auto_increment,
#  name varchar(30)
# );


# create table role_pageresource(
#  id int primary key auto_increment,
#  roleid int,
#  pageresourceid int
# );


# #用户表
# create table admin_user(
#  id int primary key auto_increment,
#  name varchar(50),
#  mobile varchar(11)
# );

# 图书表
# create table userbook(
#  id int primary key auto_increment,
#  book_name varchar(50),
#  neir text,
#  suser_id int
# );
